package com.gxa.saas.portal.mapper;

import com.gxa.saas.core.entity.FirstClassify;
import com.gxa.saas.core.vo.HomePageBannerVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @Auther: pengxtao
 * @Date: 2022/7/21下午8:57
 * 商品主页数据
 */
@Mapper
public interface GoodsHomepageMapper {

    /**
     * @return 返回商品分类名
     */
    @Select("SELECT first_classify.first_name AS firstName FROM first_classify")
    public List<FirstClassify> selectClassify();

    @Select("SELECT \n" +
            "img AS picture,description,product_id AS prId\n" +
            "FROM\n" +
            "tb_banner where status=0")
    public List<HomePageBannerVo> selectSlideshow();
}
